package com.imti.mall.order.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.imti.mall.model.pms.pojo.PmsProductLadder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ProductLadderMapper extends BaseMapper<PmsProductLadder> {

    @Select("select id,product_id,count,discount,price from pms_product_ladder where product_id=#{productId}")
    @Result(property = "productId",column = "product_id")
    PmsProductLadder productLadderByproductId(@Param("productId") Long productId);

}
